package com.demo.main.dao;

import com.demo.main.entity.Book;
import com.demo.main.utils.JDBCUtil;
import com.demo.main.vo.BookVo;

import java.sql.SQLException;
import java.util.List;
public interface BookDao extends BaseDao<Book, Integer> {
    List<BookVo> selectAllBookVo(int pageNum);
    List<BookVo> selectBookVoByCondition(String title, String author, String isbn, String bookCategoryName, int pageNum);
    int selectBookVoCountByCondition(String title, String author, String isbn, String bookCategoryName);
    JDBCUtil.StoredProcedureResult borrowBook(int userId, int bookId, int borrowDays) throws SQLException;
    JDBCUtil.StoredProcedureResult returnBook(int userId, int bookId) throws SQLException;
}